﻿
namespace ZR.Model.Models.ProductionControl
{
    /// <summary>
    /// 数据库采集配置表
    /// </summary>
    [SugarTable("database_collection_config")]
    [Table(Name = "database_collection_config")]
    public class DatabaseCollectionConfig : BaseEntity
    {
        /// <summary>
        /// 自增主键 
        /// </summary>
        [SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
        [Column(IsPrimary = true, IsIdentity = true)]
        public int Id { get; set; }

        /// <summary>
        /// 业务编码，用于业务关联 
        /// </summary>
        public string BusinessCode { get; set; }

        /// <summary>
        /// 设备名称 
        /// </summary>
        public string DeviceName { get; set; }

        /// <summary>
        /// IP地址 
        /// </summary>
        public string Ip { get; set; }

        /// <summary>
        /// 端口号 
        /// </summary>
        public int Port { get; set; }

        /// <summary>
        /// 数据库类型 0 MySql  1 SqlServer 
        /// </summary>
        public string Type { get; set; }

        /// <summary>
        /// 数据库名称 
        /// </summary>
        public string DataBase { get; set; }

        /// <summary>
        /// 用户名 
        /// </summary>
        public string Uid { get; set; }

        /// <summary>
        /// 密码 
        /// </summary>
        public string Pwd { get; set; }

        /// <summary>
        /// Nullity 
        /// </summary>
        public bool Nullity { get; set; }

        /// <summary>
        /// CreatedTime 
        /// </summary>
        public DateTime CreatedTime { get; set; } = DateTime.Now;

        

    }
}